Copy Access data into Excel

Decide whether you want to analyze an entire table or query or all of the data behind a form or report, or copy only selected records.

In the Database window in Microsoft Access, click the table, query, form, or report you want to use in Excel.
On the Tools menu, point to Office Links, and then click Analyze It With MS Excel.
Access saves the contents of the table, query, form, or report as a Excel workbook (.xls) file and opens the file in Excel. The file is saved with the name of the table, query, or other database object in the current working folder.

Note If you have a main form with one or more subforms or a main report with one or more subreports, Access saves only the data in the main form or report to the workbook.

In Microsoft Access, open the table, query, or form that contains the records you want to copy.
On the View menu, click Datasheet View.
Select the records you want to copy.
If you want to select specific columns, drag across adjacent column headings.
Click Copy .
Switch to Excel.
Click in the upper-left corner of the worksheet area where you want the first field name to appear.
To ensure that the copied records do not replace existing records, make sure that the worksheet has no date below or to the right of the cell you click.
Click Paste .
You may need to adjust the row height of data you paste onto your worksheet. Do one of the following:
- Select the rows, click Cells on the Format menu, click the Alignment tab, and then clear the Wrap text check box.
- On the Format menu point to Row, and click AutoFit.